Connect with Clients - Articles| Solutions from CDX Technologies

When Excel returns #NAME? for a CDXZipStream function instead of a value this means that the program is not correctly installed on your system. Typically this means that the add-in used for the custom functions is not registered correctly. To address this perform the following steps.

1. Make sure that all instances of Excel are closed on your system. To confirm this start the Windows "Task Manager" by pressing CTL-ALT-DEL and then clicking on this option. Select the processes tab and then sort by clicking on the "Image Name" header. Make sure there are no occurrences of Excel.exe. If there are right click on Excel.exe and then select "End Process".

2. Download and then run the latest copy of the CDXZipStream setup file which can be found at the following link:

http://www.cdxtech.com/downloads/CDXZipStream/CDXZipStreamSetup.msi

3. When the install starts, click on "Run" and when prompted press "Next". Then select the "Repair Option" and press Next. On the following screen click "Install" to set up the program. If you are unable to perform a repair, uninstall the CDXZipStream program using Window's "Add/Remove Programs" and then reinstall it.

4. If the above steps do not correct the problem check that the CDXZipStream Add-ins are enabled on your system.

In Excel 2003 select the Excel Menu item "Help" and the click on "About Microsoft Excel". In the lower right hand corner of the screen that appears press "Disabled Items". If any add-ins beginning with CDXZipStream appear, click on them to re-enable. Then restart Excel.

In Excel 2007 Click the Microsoft Office Button (the big circle in the upper left hand corner) , click Excel Options, and then click Add-Ins. Check the "Inactive Application Add-ins" or "Disabled Application Add-ins" for add-ins that start with CDXZipStream. If any appear, use the "Manage" function at the bottom of the screen. Select the type "Com Add-ins" and then make sure that add-ins with CDXZipStream are checked. Then restart Excel

5. If an error occurs when enabling add-ins you will need to run a repair of Microsoft Office. In Excel 2003 choose the Excel menu item "Help" and then run "Detect and Repair". In Excel 2007 use Start \ All Programs \ Microsoft Office \ Microsoft Office Tools \ Microsoft Office Diagnostics.